Jason Rowe ✭✭

Overview

Overview

Roles	No Roles
Badges	6

About Me

About Me

Not much happening here, yet.

Analytics

14

Posts

0

Visits

41

Points

Mar 2, 2016

Join Date

Apr 17, 2017

Last Active

Reactions

• Insightful 1

  1

• Activity
• Discussions2
• Comments12

• Re: Subtract 6 Months from Date in Another Cell

  Jason Rowe

  01/30/17
  kcain, Try this formula. It should give you exactly 6 months. =IF((MONTH([DATE COMPLETED]203) - 6) < 1, DATE(YEAR([DATE COMPLETED]203) - 1, MONTH([DATE COMPLETED]203) - 6 + 12, DAY([DATE COMPLETED…
  1 ·